package com.yuncheng.spcyApi.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuncheng.spcyApi.dto.SpcyGzjlDto;
import com.yuncheng.spcyApi.entity.SpcyOaGzjl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Description: 审评查验-工资记录
 * @Author: yuncheng
 * @Date: 2023-09-22
 * @Version: V1.0
 */
public interface SpcyOaGzjlMapper extends BaseMapper<SpcyOaGzjl> {

    /** 查询所有工资记录项详情 */
    Page<SpcyGzjlDto> findGzjlxqPage(Page<SpcyGzjlDto> page,
                                     @Param("bean") SpcyOaGzjl gzjl,
                                     @Param("gzxs")String gzxs,
                                     @Param("startYear")String startYear,
                                     @Param("endYear")String endYear,
                                     @Param("startMonth")String startMonth,
                                     @Param("endMonth")String endMonth);

    /** 工作项合计 */
    List<String> getGzjlxqHj(@Param("bean") SpcyOaGzjl gzjl,
                       @Param("gzxs")String gzxs,
                       @Param("startYear")String startYear,
                       @Param("endYear")String endYear,
                       @Param("startMonth")String startMonth,
                       @Param("endMonth")String endMonth);

    /** 查询工资记录所有姓名人员 */
    List<String> getAllGzjlUserList();

    List<SpcyOaGzjl> getGzjlList(@Param("bean") SpcyOaGzjl gzjl,
                                  @Param("gzxs")String gzxs,
                                  @Param("startYear")String startYear,
                                  @Param("endYear")String endYear,
                                  @Param("startMonth")String startMonth,
                                  @Param("endMonth")String endMonth);

    List<SpcyGzjlDto> getGzjlDtoList(@Param("fxm") String fxm,
                                  @Param("gzxs")String gzxs);

}
